How to: Change the default behavior for find/replace operations.
Solution:
Select 'Options...' from the 'Tools' menu, select one of the radio buttons in the 'Default Find/Replace Behavior' group on the 'Edit/Find' tab, and click 'Apply' or the 'OK'.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'Edit/Find' tab.
3) Do one of the following in the 'Default Find/Replace Behavior' group:
the Default Find/Replace Behavior group
a) Select the 'Fast Search' radio button to have Access search the current field and match the whole field by default.
b) Select the 'General Search' radio button to have Access search all fields and match any part of the field by default.
c) Select the 'Start of Field Search' radio button to have Access search the current field and match the beginning character or characters of the field by default.
4) Do one of the following:
a) Click 'Apply' to apply the new settings and keep the 'Options' dialog box open.
NOTE: Click 'Apply' when there are changes that need to be made to settings on another tab. This avoids having to re-open the 'Options' dialog box.
b) Click 'OK' to apply the new settings and close the 'Options' dialog box.
